{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inventory Certification","Inventory Control Report","FIFO Validation","Working Area"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":12,"comments":3,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inventory Certification","index":0,"n_rows":58,"n_cols":57,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,2,54,6],[56,2,56,6],[1,0,1,13],[35,0,41,14],[57,2,57,6],[45,2,45,6],[47,2,47,6],[50,2,50,6],[50,13,50,14],[53,2,53,6],[53,13,53,14],[32,0,32,6],[32,11,32,14],[46,2,46,6],[46,13,46,14],[44,2,44,6],[44,13,44,14],[26,0,26,11],[26,13,26,14],[28,0,28,11],[30,0,30,6],[30,11,30,14],[7,11,7,13],[9,11,9,13],[21,9,23,12],[25,9,25,12],[11,11,11,13],[13,4,15,9],[13,11,15,13]]}
[]
["INVENTORY NIL CERTIFICATION - Q2 - 30th  JUNE 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NGF","GF","OS","PUB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…","…","…","…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item held for UNDP office's administrative use.","Item held for UNDP office's administrative use.","Item held for UNDP office's administrative use.","Item held for UNDP office's administrative use."]
[]
["Inventory Certification Type",null,null,null,"Reported project classification",null,null,null,null,null,null,"Reported Project IDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item held by a DIM project for distribution to a beneficiary under a program mandate","Item held by a DIM project for distribution to a beneficiary under a program mandate","Item held by a DIM project for distribution to a beneficiary under a program mandate","Item held by a DIM project for distribution to a beneficiary under a program mandate"]
[null,null,{"$f":"IF(A2=\"OFFICE SUPPLIES AND FUELS CERTIFICATION - Q3 - 30th  SEPTEMBER 2014\",\"( Please make a CHECK mark close to the category where applicable )\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item \"temporarily\" held by UNDP to be distributed under a NIM / NGO project modality. ","Item held for distribution under a Global Fund project",null,"Item held for distribution under a Global Fund project"]
[null,"NON-GLOBAL FUND",null,null,null,"Existing project(s) reported in previous quarter",null,null,null,null,null,"00079948",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item held by UNDP for distribution to or on behalf of  other UN agencies under common services project","Item \"temporarily\" held by UNDP to be distributed under a NIM / NGO project modality. ",null,"Item \"temporarily\" held by UNDP to be distributed under a NIM / NGO project modality. "]
[]
[null,"GLOBAL FUND",null,null,null,"Transfer from closed project(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items held for distribution under full support to NIM ","Item held by UNDP for distribution to or on behalf of  other UN agencies under common services project",null,"Item held by UNDP for distribution to or on behalf of  other UN agencies under common services project"]
[]
[null,"PUBLICATIONS ",null,null,null,"New project(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Publications held for free distribution","Items held for distribution under full support to NIM ",null,"Items held for distribution under full support to NIM "]
[]
[null,"OFFICE SUPPLIES & FUEL",null,null,"List of closed projects where inventory where transferred from",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Publications held for sale ","Publications held for free distribution",null,"Publications held for free distribution"]
[]
[null,"OFFICE SUPPLIES ONLY"]
[]
[null,"FUEL ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Publications held for sale ",null,"Publications held for sale "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Inventory Control Report'!N8","v":"00079948"}]
["Project ID:"]
[]
[]
["Country Office:",null,null,null,null,null,null,null,null,{"$f":"+'Inventory Control Report'!N7","v":"Kuwait"}]
[]
["Actual Date of Physical Count undertaken/ completed:",null,null,null,null,null,null,null,null,{"$f":"+'Inventory Control Report'!J7","v":"2015-06-30"}]
[]
["Total Value ( USD) of the Inventory per Inventory Control Report submitted:",null,null,null,null,null,null,null,null,{"$f":"IF(OR(A2='Working Area'!P4,A2='Working Area'!P10),0,'Inventory Control Report'!AN65)","v":0}]
[]
["Physical Count  performed by :",null,null,null,null,null,null,null,null,"Heba Ghoniem"]
[]
["Physical Count  and Valuation approved by :",null,null,null,null,null,null,null,null,"Sahar Shawa"]
[]
[{"$f":"IF(OR(A2='Working Area'!P4,A2='Working Area'!P10),'Working Area'!Q22,'Working Area'!Q23)","v":"This is to certify that , based on the Q2-2015 guidance on the physical count of the inventory  received from the UNDP HQ , there are no balances for the above selected inventory certification type(s) to be reported by the country office  as at 30 June 2015"}]
[]
[]
[]
[]
[]
[]
[]
[]
["Reviewed by :"]
[null,null,"Dima AL-Khatib"]
[null,null,"Name of DRR or DCD - Operations ",null,null,null,null,null,null,null,null,null,null,"Signature"]
[]
[]
["Certified by : "]
[]
["Signature:",null,null,null,null,null,null,null,null,null,null,"Date :",null,null,"2015-07-07"]
[]
[]
["Name:",null,"Mubashar Sheikh"]
[]
[]
["Title: ",null,"Resident Representative / Head of Office"]

{"sheet":"Inventory Control Report","index":1,"n_rows":65,"n_cols":40,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,1,64,16],[6,13,6,14],[7,13,7,15],[10,35,10,37],[10,22,10,24],[6,9,6,11],[7,9,7,11],[9,3,9,11],[10,3,10,11],[6,4,6,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INVENTORY CONTROL REPORT - JUNE 2015"]
[]
[]
[]
[]
[null,null,null,null,"Actual date of the completion of the physical count ",null,null,null,null,"2015-06-30",null,null,"Country Office:","Kuwait",null,{"$f":"VLOOKUP(N7,'Working Area'!$J$3:$K$230,2,FALSE)","v":"KWT"}]
[null,null,null,null,"Submission type (use drop down menu)",null,null,null,null,"…",null,null,"Project ID","00079948",null,null,{"$f":"IF(J8=\"Non Global Fund\",\"NGF\",IF(J8=\"Office Supplies and Fuel\",\"OS\",IF(J8=\"Global Fund\",\"GF\",IF(J8=\"Publications\",\"PUB\",\"\"))))","v":""},{"$f":"IF(J8=\"Non Global Fund\",\"ICNGF\",IF(J8=\"Office Supplies and Fuel\",\"ICOS\",IF(J8=\"Global Fund\",\"ICGF\",IF(J8=\"Publications\",\"ICPUB\",\"\"))))","v":""}]
[]
[null,1,2,3,null,null,null,null,null,null,null,null,4,5,6,7,8,9,10,11,"12=9+10-11",null,13,14,"15=13+14","16=15-12","17=14",null,18,19,20,21,22,23,null,24,25,26,null,"27=23+26"]
[null,null,null,"Full COA Charged Per Item Reported ( spelling must be based on ATLAS record) ",null,null,null,null,null,null,null,null,null,"Please ensure that you select your Submission Type above to enable the drop down list based on the Inventory Category","Please ensure that you select your Submission Type above to enable the drop down list based on the Inventory Category",null,null,"This should be same as CLOSING BALANCE  REPORTED  AS AT 31 Mar 2015 (If you do not have details ask GSSC to send the worksheet for this project ). OPENING BALANCE (QTY)","Please read comment attached to this cell",null,null,null,"Physical Count Balance (QTY) as of 30 June 2015",null,null,null,"(Good and usable items only)  as of 30 June 2015",null,"Assume FIFO method Important: Please read carefully , the relevant section of the guidance note, before filling this column. Include all related costs ( actual or estimated).","(Assume FIFO method)","(Assume FIFO method)","(Assume FIFO method)","Important: This column seeks the current values of the items as at 30 June 2015. Please fill in this columns using the current market unit prices in equivalent USD. ( Please note : value in this column should market prices X qty in column 17 ) This will require collection of data from the markets / vendors/ LTA/Price bulletins / quotes / phone calls etc which have to be documented",null,null,"Inventory In Transit ( on FOB incoterms ) as of 30 June 2015"]
[null,"Count","Item Number (per Procurement Catalogue, if available)","Project ID \n(eg: 00012345)","Dept ID\n(eg: 23456)","Account \n(eg: 72505)","Donor \n(eg: 00012)","Fund \n(eg: 02300)","Implementing Agent\n(eg: 001981)","Oper Unit\n(eg: H17)","PC BU\n(eg: ABC10)","Activity ID  (as per ATLAS)","Item description (where possible please indicate the Brand or Model of items)","Item Category                             ( Select from the drop down)","Purpose of this item in storage location                                    (select from drop down menu)","Is this item a donated item to UNDP ?                        (select from drop down menu)","Unit of Measurement (select one from the display)","OPENING BALANCE  (QTY)","Quantity Received or transferred-in (since 31 Mar 2015)","Quantity Issued or transferred out or disposed  (since 31  Mar 2015)","Ending Balance (QTY) as per records, as of 30 June 2015",null,"Damaged, date expired, and unusable items","Good and usable items","Total","Difference between physical count in column 15 and the records in column 12                                        (Lost , stolen & unreconciled) ","QTY of Reportable Inventory Balance ",null,"Calculated \"Cost\" of the Inventory balance reported in column 17 or 14","PO No(s) Reference for the balance in column 18\n","Related Voucher No(s), for the balance in column 18)","Related GLJE ID(s), for the balance in column 18)","Valuation of inventory ","Reportable value of the inventory balance (Lower of column 18 and column 22)",null,"Quantity in transit (QTY)","ALTAS receipt ID","Purchase Value (in USD equivalent)",null,"Total value of  Inventories + Inventory In Transit"]
[null,1,null,"00079948",null,null,null,null,null,null,null,null,null,null,"…",null,null,null,null,null,{"$f":"R13+S13-T13","v":0},null,null,null,{"$f":"X13+W13","v":0},{"$f":"Y13-U13","v":0},{"$f":"X13","v":0},null,null,null,null,null,null,{"$f":"IF(AA13=0,0,IF(AG13=\"\",\"Col 22 cannot be left blank\", IF(AG13 = 0, \"Col 22 should not be zero\", IF(AC13<AG13,AC13,AG13))))","v":0},null,null,null,null,null,{"$f":"AH13+AL13","v":0}]
[null,{"$f":"B13+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"IF(AA14=0,0,IF(AG14=\"\",\"Col 22 cannot be left blank\", IF(AG14 = 0, \"Col 22 should not be zero\", IF(AC14<AG14,AC14,AG14))))","v":0},null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R45+S45-T45","v":0},null,null,null,{"$f":"X45+W45","v":0},{"$f":"Y45-U45","v":0},{"$f":"X45","v":0},null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"AH45+AL45","v":0}]
[null,{"$f":"B45+1","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,0,0,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"GRAND TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R13:R64)","v":0},{"$f":"SUM(S13:S64)","v":0},{"$f":"SUM(T13:T64)","v":0},{"$f":"SUM(U13:U64)","v":0},null,{"$f":"SUM(W13:W64)","v":0},{"$f":"SUM(X13:X64)","v":0},{"$f":"SUM(Y13:Y64)","v":0},{"$f":"SUM(Z13:Z64)","v":0},{"$f":"SUM(AA13:AA64)","v":0},null,{"$f":"SUM(AC13:AC64)","v":0},null,null,null,null,{"$f":"SUM(AH13:AH64)","v":0},null,{"$f":"SUM(AJ13:AJ64)","v":0},{"$f":"SUM(AK13:AK64)","v":0},{"$f":"SUM(AL13:AL64)","v":0},null,{"$f":"SUM(AN13:AN64)","v":0}]

{"sheet":"FIFO Validation","index":2,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[[18,1,18,10],[3,14,4,14],[3,15,4,15],[5,13,6,13],[5,14,6,14],[5,15,6,15],[3,13,4,13],[11,3,11,6],[10,3,10,6],[0,12,0,15],[2,1,2,10],[3,1,8,10],[10,8,10,9],[11,8,11,10]]}
[null,"FIFO Validation Sheet",null,null,null,null,null,null,null,null,null,null,"Example of FIFO Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Count ID: 132","Units ","Price / Unit ","Value "]
[null,"This sheet is used to validate the FIFO Calculation for the 2 items with largest ending balance by value of the Inventory Control Report (Value $).                                                                                                                                                          ",null,null,null,null,null,null,null,null,null,null,"Balance in Hand ",50]
[null,"Calculation of “Cost” calculation of the reported inventory balances should be based on ‘vouchered’ amounts. Further, as per the IPSAS standard, the cost of Inventories must include all related costs of purchase , cost of conversion and other costs incurred in bringing the inventories to present location and condition. All costs incurred such as (i) the purchase price, (ii) import duties and other taxes (other than those subsequently recoverable by UNDP from the taxing authorities), (iii) transport costs (iv) handling costs and (v) other costs directly attributable to the acquisition of inventories have to be considered in calculating the cost of inventory balance. GMS has to be excluded. Therefore, all related vouchers should be considered for the cost of calculation of the inventory balances. If it is difficult to trace the related costs, please use some good measures of estimates and include to the cost calculated above and input in the column 18.                                                                                                                                                                                                                                                                                       ",null,null,null,null,null,null,null,null,null,null,"Last invoice ",30,5,150]
[null,null,null,null,null,null,null,null,null,null,null,null,"(bought 30 units) "]
[null,null,null,null,null,null,null,null,null,null,null,null,"2nd last invoice ",20,7,140]
[null,null,null,null,null,null,null,null,null,null,null,null,"(bought 40 units) "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total cost of item ‘A’ in hand at quarter-end** ",null,null,290]
[]
[]
[null,"Actual date of the completion of the physical count: ",null,{"$f":"+'Inventory Control Report'!J7","v":"2015-06-30"},null,null,null,"Country Office:",{"$f":"+'Inventory Control Report'!N7","v":"Kuwait"},null,{"$f":"VLOOKUP(I11,'Working Area'!$J$3:$K$230,2,FALSE)","v":"KWT"}]
[null,"Submission type ( use drop down menu):",null,{"$f":"+'Inventory Control Report'!J8","v":"…"},null,null,null,"Project ID","00079948 00075597"]
[]
[]
[null,null,null,"To be completed by CO / HQ unit Inventory Focal Point"]
[]
[null,"Column 18: Calculation of \"cost\" of physical count balance of good & usable items"]
[]
[null,"The “cost” of the inventory items on hand has to be based on FIFO approach (First in First out approach) and hence the prices of the latest purchases that will make up the physical balance have to be considered.  The values should be equivalent USD amounts as on the date of the Purchase. Please use the example next to this sheet as an example to fill the table below for the two largest items of the Inventory Control Report (in terms $ value per row). You can insert as many rows as needed for the calculation of the FIFO."]
[]
[null,"Sample for the first largest items in terms of value  ",null,null,null,null,null,"Sample for the second largest items in terms of value  "]
[null,"Count ID: ….","Units ","Price / Unit ","Value ",null,null,"Count ID: ….","Units ","Price / Unit ","Value "]
[null,"Balance in Hand ",null,null,null,null,null,"Balance in Hand "]
[null,"Invoice 1: ………. Units",null,null,{"$f":"+C24*D24","v":0},null,null,"Invoice 1: ………. Units",null,null,{"$f":"+I24*J24","v":0}]
[null,"Invoice 2: ………. Units",null,null,{"$f":"+C25*D25","v":0},null,null,"Invoice 2: ………. Units",null,null,{"$f":"+I25*J25","v":0}]
[null,"Invoice 3: ………. Units",null,null,0,null,null,"Invoice 3: ………. Units",null,null,0]
[null,"Invoice 4: ………. Units",null,null,0,null,null,"Invoice 4: ………. Units",null,null,0]
[null,"Cost of item in hand at quarter-end **",null,null,{"$f":"SUM(E24:E27)","v":0},null,null,"Cost of item in hand at quarter-end  **",null,null,{"$f":"SUM(K24:K27)","v":0}]
[]
[null,"** Only the values thus arrived (highlighted) has to be included in column 18. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C24:C71)","v":0},null,null,null,null,null,{"$f":"SUM(I24:I71)","v":0}]

{"sheet":"Working Area","index":3,"n_rows":238,"n_cols":34,"rows_kept":238,"cut":false,"hidden":true,"merged":[[9,16,9,17],[11,16,11,17],[13,16,13,17]]}
[null,null,null,null,null,null,null,null,null,"OU Descr","OU"]
["OU Descr","OU",null,null,null,null,null,null,null,"…","…"]
["Advisory Comm. on Procurement","H31",null,null,null,null,null,null,null,"Advisory Comm. on Procurement","H31",null,null,null,null,"INVENTORY CERTIFICATION - Q2 - 30th  JUNE 2015"]
["Afghanistan","AFG",null,null,null,null,null,null,null,"Afghanistan","AFG",null,null,null,null,"INVENTORY NIL CERTIFICATION - Q2 - 30th  JUNE 2015"]
["Albania","ALB",null,null,null,null,null,null,null,"Albania","ALB"]
["Algeria","DZA",null,null,null,null,null,null,null,"Algeria","DZA"]
["Angola","AGO",null,null,null,null,null,null,null,"Angola","AGO"]
["Anguilla","AIA",null,null,null,null,null,null,null,"Anguilla","AIA"]
["Antigua and Barbuda","ATG",null,null,null,null,null,null,null,"Antigua and Barbuda","ATG"]
["Argentina","ARG",null,null,null,null,null,null,null,"Argentina","ARG"]
["Armenia","ARM",null,null,null,null,null,null,null,"Armenia","ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICNGF","ICGF","ICOS","ICPUB","NGF","GF","OS","PUB"]
["Aruba","ABW",null,null,null,null,null,null,null,"Aruba","ABW",null,null,null,null,null,"?",null,null,null,null,null,null,null,null,null,"…","…","…","…","…","…","…","…"]
["Azerbaijan","AZE",null,null,null,null,null,null,null,"Azerbaijan","AZE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUEL","MEDICAL","FUEL","HDR","Item held by a DIM project for distribution to a beneficiary under a program mandate","Item held by a DIM project for distribution to a beneficiary under a program mandate","Item held for UNDP office's administrative use.","Publications held for free distribution"]
["Bahamas","BHS",null,null,null,null,null,null,null,"Bahamas","BHS",null,null,null,null,null,"?",null,null,null,null,null,null,null,null,null,"MEDICAL","IT","MEDICAL","PUBLICATON","Item \"temporarily\" held by UNDP to be distributed under a NIM / NGO project modality. ","Item held for distribution under a Global Fund project","Item held by a DIM project for distribution to a beneficiary under a program mandate","Publications held for sale "]
["Bahrain","BHR",null,null,null,null,null,null,null,"Bahrain","BHR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELECTORAL","OTHERS","IT","OTHERS","Item held by UNDP for distribution to or on behalf of  other UN agencies under common services project","Item \"temporarily\" held by UNDP to be distributed under a NIM / NGO project modality. ","Item held for DIM project office administrative use."]
["Bangladesh","BGD",null,null,null,null,null,null,null,"Bangladesh","BGD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRISIS",null,"OFFICE",null,"Items held for distribution under full support to NIM ","Item held by UNDP for distribution to or on behalf of  other UN agencies under common services project"]
["Barbados","BRB",null,null,null,null,null,null,null,"Barbados","BRB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT",null,"OTHERS",null,"Items held for distribution on behalf of UNDSS ","Items held for distribution under full support to NIM "]
["BCPR","H10",null,null,null,null,null,null,null,"BCPR","H10",null,null,null,null,null,"?",null,null,null,null,null,null,null,null,null,"OFFICE",null,null,null,"Item held for DIM project office administrative use"]
["Belarus, Republic of","BLR",null,null,null,null,null,null,null,"Belarus, Republic of","BLR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHERS",null,null,null,"Item distributed to beneficiaries but pending legal transfer"]
["Belize","BLZ",null,null,null,null,null,null,null,"Belize","BLZ"]
["Benin","BEN",null,null,null,null,null,null,null,"Benin","BEN"]
["Bermuda","BMU",null,null,null,null,null,null,null,"Bermuda","BMU",null,null,null,null,null,"This is to certify that , based on the Q2-2015 guidance on the physical count of the inventory  received from the UNDP HQ , there are no balances for the above selected inventory certification type(s) to be reported by the country office  as at 30 June 2015"]
["Bhutan","BTN",null,null,null,null,null,null,null,"Bhutan","BTN",null,null,null,null,null,"This is to certify that , based on the Q2-2015  physical count of the inventory carried out and the inventory reports submitted for the above project(s), the value of inventory balances reported as indicated above is accurate and complete , in accordance with the guidance note received from the UNDP HQ for the purpose.  This is to further certify that all the inventories that are in the  control of UNDP (including the inventory in transit under FOB incoterms ) have been included in this report . Their associated costs and valuations are calculated and reported correctly in accordance with the guidance note received . Any unreconciled differences in quantities  between physical count and local inventory records, if reported under column 16 of the Inventory Control Report , are being investigated for further actions."]
["Bolivia","BOL",null,null,null,null,null,null,null,"Bolivia","BOL"]
["BOM/Ofc of Asst Administrator","H22",null,null,null,null,null,null,null,"BOM/Ofc of Asst Administrator","H22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel",null,null,null,"Fuel"]
["Bosnia and Herzegovina","BIH",null,null,null,null,null,null,null,"Bosnia and Herzegovina","BIH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Medical",null,null,null," Medical"]
["Botswana","BWA",null,null,null,null,null,null,null,"Botswana","BWA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Electoral supplies ",null,null,null,"  Toners"]
["Bratislava Regional Center","SVK",null,null,null,null,null,null,null,"Bratislava Regional Center","SVK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crisis related",null,null,null," Other IT supplies"]
["Brazil","BRA",null,null,null,null,null,null,null,"Brazil","BRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," HDR reports",null,null,null," Visibility items "]
["Bulgaria","BGR",null,null,null,null,null,null,null,"Bulgaria","BGR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other publications",null,null,null," Office supplies and stationery"]
["Bureau for Dev. Policy","H21",null,null,null,null,null,null,null,"Bureau for Dev. Policy","H21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," IT supplies",null,null,null,"Cleaning supplies"]
["Burkina Faso","BFA",null,null,null,null,null,null,null,"Bureau Policy & Prog Support","H70",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Office supplies",null,null,null,"Other"]
["Burundi","BDI",null,null,null,null,null,null,null,"Burkina Faso","BFA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleaning supplies"]
["Cairo Regional Center","R44",null,null,null,null,null,null,null,"Burundi","BDI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
["Cambodia","KHM",null,null,null,null,null,null,null,"Cairo Regional Center","R44"]
["Cameroon, Republic of","CMR",null,null,null,null,null,null,null,"Cambodia","KHM"]
["Cape Verde","CPV",null,null,null,null,null,null,null,"Cameroon, Republic of","CMR"]
["Cayman Islands","CYM",null,null,null,null,null,null,null,"Cape Verde","CPV"]
["Central African Republic","CAF",null,null,null,null,null,null,null,"Cayman Islands","CYM"]
["Chad","TCD",null,null,null,null,null,null,null,"Central African Republic","CAF"]
["Chile","CHL",null,null,null,null,null,null,null,"Chad","TCD"]
["China","CHN",null,null,null,null,null,null,null,"Chile","CHL"]
["Colombia","COL",null,null,null,null,null,null,null,"China","CHN"]
["Communications Office","H41",null,null,null,null,null,null,null,"Colombia","COL"]
["Comoros","COM",null,null,null,null,null,null,null,"Colombo Regional Centre","R42"]
["Congo","COG",null,null,null,null,null,null,null,"Communications Office","H41"]
["Cook Islands","COK",null,null,null,null,null,null,null,"Comoros","COM"]
["Corporate Business Solutions","H47",null,null,null,null,null,null,null,"Congo","COG"]
["Costa Rica","CRI",null,null,null,null,null,null,null,"Cook Islands","COK"]
["Côte d’Ivoire","CIV",null,null,null,null,null,null,null,"Corporate Business Solutions","H47"]
["Croatia","HRV",null,null,null,null,null,null,null,"Costa Rica","CRI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRISIS","Crisis supplies and equipment"]
["Cuba","CUB",null,null,null,null,null,null,null,"Côte d’Ivoire","CIV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELECTORAL","Electoral supplies and equipment"]
["Curacao","CUV",null,null,null,null,null,null,null,"Crisis Response Unit","H71",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUEL","Fuel"]
["Cyprus","CYP",null,null,null,null,null,null,null,"Croatia","HRV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HDR","Human Development reports (HDRs)"]
["Dakar Regional Service Centre","R11",null,null,null,null,null,null,null,"Cuba","CUB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Information technology supplies and consumables"]
["Democr People's Repub of Korea","PRK",null,null,null,null,null,null,null,"Curacao","CUV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEDICAL","Medical supplies and equipment "]
["Democratic Republic of Congo","COD",null,null,null,null,null,null,null,"Cyprus","CYP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICE","Office supplies"]
["Djibouti","DJI",null,null,null,null,null,null,null,"Dakar Regional Service Centre","R11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUBLICATON","Publications"]
["Dominica","DMA",null,null,null,null,null,null,null,"Democr People's Repub of Korea","PRK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHERS","Other project related inventories "]
["Dominican Republic","DOM",null,null,null,null,null,null,null,"Democratic Republic of Congo","COD"]
["Ecuador","ECU",null,null,null,null,null,null,null,"Djibouti","DJI"]
["Egypt","EGY",null,null,null,null,null,null,null,"Dominica","DMA"]
["El Salvador","SLV",null,null,null,null,null,null,null,"Dominican Republic","DOM"]
["Equatorial Guinea","GNQ",null,null,null,null,null,null,null,"Ecuador","ECU"]
["Eritrea","ERI",null,null,null,null,null,null,null,"Egypt","EGY"]
["Ethics Office","H57",null,null,null,null,null,null,null,"El Salvador","SLV"]
["Ethiopia","ETH",null,null,null,null,null,null,null,"Equatorial Guinea","GNQ"]
["Evaluation Office","H11",null,null,null,null,null,null,null,"Eritrea","ERI"]
["Fiji","FJI",null,null,null,null,null,null,null,"Ethics Office","H57"]
["Gabon","GAB",null,null,null,null,null,null,null,"Ethiopia","ETH"]
["Gambia","GMB",null,null,null,null,null,null,null,"Evaluation Office","H11"]
["Georgia","GEO",null,null,null,null,null,null,null,"Fiji","FJI"]
["GFATM unit","H58",null,null,null,null,null,null,null,"Gabon","GAB"]
["Ghana","GHA",null,null,null,null,null,null,null,"Gambia","GMB"]
["Grenada","GRD",null,null,null,null,null,null,null,"Georgia","GEO"]
["Guatemala","GTM",null,null,null,null,null,null,null,"GFATM unit","H58"]
["Guinea","GIN",null,null,null,null,null,null,null,"Ghana","GHA"]
["Guinea-Bissau","GNB",null,null,null,null,null,null,null,"Grenada","GRD"]
["Guyana","GUY",null,null,null,null,null,null,null,"Guatemala","GTM"]
["Haiti","HTI",null,null,null,null,null,null,null,"Guinea","GIN"]
["Honduras","HND",null,null,null,null,null,null,null,"Guinea-Bissau","GNB"]
["Human Development Report Ofc","H43",null,null,null,null,null,null,null,"Guyana","GUY"]
["India","IND",null,null,null,null,null,null,null,"Haiti","HTI"]
["Indonesia","IDN",null,null,null,null,null,null,null,"Honduras","HND"]
["Inter-Agency Procurmnt Srvc Of","H12",null,null,null,null,null,null,null,"Human Development Report Ofc","H43"]
["Iran, Islamic Republic of","IRN",null,null,null,null,null,null,null,"India","IND"]
["Iraq","IRQ",null,null,null,null,null,null,null,"Indonesia","IDN"]
["Jamaica","JAM",null,null,null,null,null,null,null,"Inter-Agency Procurmnt Srvc Of","H12"]
["Jordan","JOR",null,null,null,null,null,null,null,"Iran, Islamic Republic of","IRN"]
["Kazakhstan","KAZ",null,null,null,null,null,null,null,"Iraq","IRQ"]
["Kenya","KEN",null,null,null,null,null,null,null,"Jamaica","JAM"]
["Kiribati","KIR",null,null,null,null,null,null,null,"Jordan","JOR"]
["Korea, Republic of","KOR",null,null,null,null,null,null,null,"Kazakhstan","KAZ"]
["Kosovo","KOS",null,null,null,null,null,null,null,"Kenya","KEN"]
["Kuwait","KWT",null,null,null,null,null,null,null,"Kiribati","KIR"]
["Kyrgyzstan","KGZ",null,null,null,null,null,null,null,"Korea, Republic of","KOR"]
["Lao People's Democratic Republ","LAO",null,null,null,null,null,null,null,"Kosovo","KOS"]
["Latvia, Republic of","LVA",null,null,null,null,null,null,null,"Kuwait","KWT"]
["Lebanon","LBN",null,null,null,null,null,null,null,"Kyrgyzstan","KGZ"]
["Legal Support Office","H56",null,null,null,null,null,null,null,"Lao People's Democratic Republ","LAO"]
["Lesotho","LSO",null,null,null,null,null,null,null,"Latvia, Republic of","LVA"]
["Liberia","LBR",null,null,null,null,null,null,null,"Lebanon","LBN"]
["Libya","LBY",null,null,null,null,null,null,null,"Legal Support Office","H56"]
["Lithuania, Republic of","LTU",null,null,null,null,null,null,null,"Lesotho","LSO"]
["Macedonia, former Yugoslav Rep","MKD",null,null,null,null,null,null,null,"Liberia","LBR"]
["Madagascar","MDG",null,null,null,null,null,null,null,"Libya","LBY"]
["Malawi","MWI",null,null,null,null,null,null,null,"Lithuania, Republic of","LTU"]
["Malaysia","MYS",null,null,null,null,null,null,null,"Macedonia, former Yugoslav Rep","MKD"]
["Maldives","MDV",null,null,null,null,null,null,null,"Madagascar","MDG"]
["Mali","MLI",null,null,null,null,null,null,null,"Malawi","MWI"]
["Management Consulting Team-BOM","H30",null,null,null,null,null,null,null,"Malaysia","MYS"]
["Marshall Islands","MHL",null,null,null,null,null,null,null,"Maldives","MDV"]
["Mauritania","MRT",null,null,null,null,null,null,null,"Mali","MLI"]
["Mauritius","MUS",null,null,null,null,null,null,null,"Management Consulting Team-BOM","H30"]
["Mexico","MEX",null,null,null,null,null,null,null,"Marshall Islands","MHL"]
["Micronesia, Federated Statesof","FSM",null,null,null,null,null,null,null,"Mauritania","MRT"]
["Moldova, Republic of","MDA",null,null,null,null,null,null,null,"Mauritius","MUS"]
["Mongolia","MNG",null,null,null,null,null,null,null,"Mexico","MEX"]
["Montenegro","MNE",null,null,null,null,null,null,null,"Micronesia, Federated Statesof","FSM"]
["Montserrat","MSR",null,null,null,null,null,null,null,"Moldova, Republic of","MDA"]
["Morocco","MAR",null,null,null,null,null,null,null,"Mongolia","MNG"]
["Mozambique","MOZ",null,null,null,null,null,null,null,"Montenegro","MNE"]
["Multi Donor Trust Fund Office","H61",null,null,null,null,null,null,null,"Montserrat","MSR"]
["Myanmar","MMR",null,null,null,null,null,null,null,"Morocco","MAR"]
["Namibia","NAM",null,null,null,null,null,null,null,"Mozambique","MOZ"]
["Nauru","NRU",null,null,null,null,null,null,null,"Multi Donor Trust Fund Office","H61"]
["Nepal","NPL",null,null,null,null,null,null,null,"Myanmar","MMR"]
["Netherlands Antilles","ANT",null,null,null,null,null,null,null,"Namibia","NAM"]
["Nicaragua","NIC",null,null,null,null,null,null,null,"Nauru","NRU"]
["Niger","NER",null,null,null,null,null,null,null,"Nepal","NPL"]
["Nigeria","NGA",null,null,null,null,null,null,null,"Netherlands Antilles","ANT"]
["Niue","NIU",null,null,null,null,null,null,null,"Nicaragua","NIC"]
["Non Specific CO","H53",null,null,null,null,null,null,null,"Niger","NER"]
["Non Specific HQ","H52",null,null,null,null,null,null,null,"Nigeria","NGA"]
["Ofc of Audit and Investigation","H14",null,null,null,null,null,null,null,"Niue","NIU"]
["Ofc of Info Systems&Technology","H48",null,null,null,null,null,null,null,"Non Specific CO","H53"]
["Office for Development Studies","H54",null,null,null,null,null,null,null,"Non Specific HQ","H52"]
["Office of Finance","H17",null,null,null,null,null,null,null,"Ofc of Audit and Investigation","H14"]
["Office of Financial Res Mgmt","H35",null,null,null,null,null,null,null,"Ofc of Info Systems&Technology","H48"]
["Office of Human Resources","H18",null,null,null,null,null,null,null,"Office for Development Studies","H54"]
["Office of Ombudsman","H51",null,null,null,null,null,null,null,"Office of Finance","H17"]
["Office of Planning & Budgeting","H15",null,null,null,null,null,null,null,"Office of Financial Res Mgmt","H35"]
["Office of the Administrator","H13",null,null,null,null,null,null,null,"Office of Human Resources","H18"]
["Operations Support Group","H20",null,null,null,null,null,null,null,"Office of Ombudsman","H51"]
["Pacific Centre (PC)","PSC",null,null,null,null,null,null,null,"Office of Planning & Budgeting","H15"]
["Pakistan","PAK",null,null,null,null,null,null,null,"Office of the Administrator","H13"]
["Panama","PAN",null,null,null,null,null,null,null,"Operations Support Group","H20"]
["Panama Regional Center","R46",null,null,null,null,null,null,null,"Pacific Centre (PC)","PSC"]
["Papua New Guinea","PNG",null,null,null,null,null,null,null,"Pacific Sub-Regional Centre","R43"]
["Paraguay","PRY",null,null,null,null,null,null,null,"Pakistan","PAK"]
["PB","H23",null,null,null,null,null,null,null,"Panama","PAN"]
["PB/Liaison/Brussels","H27",null,null,null,null,null,null,null,"Panama Regional Center","R46"]
["PB/Liaison/Copenhagen","H28",null,null,null,null,null,null,null,"Panama Regional Center","R46"]
["PB/Liaison/Geneva","H24",null,null,null,null,null,null,null,"Panama Regional Centre","R46"]
["PB/Liaison/Tokyo","H25",null,null,null,null,null,null,null,"Papua New Guinea","PNG"]
["PB/Liaison/Washington","H26",null,null,null,null,null,null,null,"Paraguay","PRY"]
["PB/South Korea Liaison Office","H62",null,null,null,null,null,null,null,"PB","H23"]
["Peru","PER",null,null,null,null,null,null,null,"PB/Liaison/Brussels","H27"]
["Philippines","PHL",null,null,null,null,null,null,null,"PB/Liaison/Copenhagen","H28"]
["Poland","POL",null,null,null,null,null,null,null,"PB/Liaison/Geneva","H24"]
["Procurement Support Office","H19",null,null,null,null,null,null,null,"PB/Liaison/Tokyo","H25"]
["Prog for Palestinian People","PAL",null,null,null,null,null,null,null,"PB/Liaison/Washington","H26"]
["Qatar","QAT",null,null,null,null,null,null,null,"PB/South Korea Liaison Office","H62"]
["Reg Bur for Arab States","H05",null,null,null,null,null,null,null,"Peru","PER"]
["Reg Bur for Europe & CIS","H02",null,null,null,null,null,null,null,"Philippines","PHL"]
["Reg Bur Latin Amer & Carib","H03",null,null,null,null,null,null,null,"Poland","POL"]
["Reg Bureau for Africa","H01",null,null,null,null,null,null,null,"Procurement Support Office","H19"]
["Reg Bureau for Asia & Pacific","H04",null,null,null,null,null,null,null,"Prog for Palestinian People","PAL"]
["Regional Center - Addis Ababa","R12",null,null,null,null,null,null,null,"Qatar","QAT"]
["Regional SC - Johannesburg","RJB",null,null,null,null,null,null,null,"Reg Bur for Arab States","H05"]
["Republic of Palau","PLW",null,null,null,null,null,null,null,"Reg Bur for Europe & CIS","H02"]
["Rgnl Center in Bangkok (RCB)","BRC",null,null,null,null,null,null,null,"Reg Bur Latin Amer & Carib","H03"]
["Rgnl Centre in Colombo (RCC)","CRC",null,null,null,null,null,null,null,"Reg Bureau for Africa","H01"]
["Rgnl Ctr in Trinidad & Tobago","R45",null,null,null,null,null,null,null,"Reg Bureau for Asia & Pacific","H04"]
["Romania","ROU",null,null,null,null,null,null,null,"Regional Center - Addis Ababa","R12"]
["Russian Federation","RUS",null,null,null,null,null,null,null,"Regional Center In Amman","R47"]
["Rwanda","RWA",null,null,null,null,null,null,null,"Regional Centre in Bangkok","R41"]
["Samoa","WSM",null,null,null,null,null,null,null,"Regional SC - Johannesburg","RJB"]
["Sao Tome and Principe","STP",null,null,null,null,null,null,null,"Regional SC - Johannesburg","RJB"]
["Saudi Arabia","SAU",null,null,null,null,null,null,null,"Republic of Palau","PLW"]
["Security Operations","H46",null,null,null,null,null,null,null,"Rgnl Center in Bangkok (RCB)","BRC"]
["Senegal","SEN",null,null,null,null,null,null,null,"Rgnl Centre in Colombo (RCC)","CRC"]
["Serbia","SRB",null,null,null,null,null,null,null,"Rgnl Ctr in Trinidad & Tobago","R45"]
["Seychelles","SYC",null,null,null,null,null,null,null,"Romania","ROU"]
["Sierra Leone","SLE",null,null,null,null,null,null,null,"Russian Federation","RUS"]
["Sint Maarten","SXM",null,null,null,null,null,null,null,"Rwanda","RWA"]
["Solomon Islands","SLB",null,null,null,null,null,null,null,"Samoa","WSM"]
["Somalia","SOM",null,null,null,null,null,null,null,"Sao Tome and Principe","STP"]
["South Africa","ZAF",null,null,null,null,null,null,null,"Saudi Arabia","SAU"]
["South Sudan, Republic of","SSD",null,null,null,null,null,null,null,"Security Operations","H46"]
["Spcl Unit for South South Coop","H42",null,null,null,null,null,null,null,"Senegal","SEN"]
["Sri Lanka","LKA",null,null,null,null,null,null,null,"Serbia","SRB"]
["St. Kitts and Nevis","KNA",null,null,null,null,null,null,null,"Seychelles","SYC"]
["St. Lucia","LCA",null,null,null,null,null,null,null,"Sierra Leone","SLE"]
["St. Vincent and the Grenadines","VCT",null,null,null,null,null,null,null,"Sint Maarten","SXM"]
["Staff Council Secretariat","H49",null,null,null,null,null,null,null,"Solomon Islands","SLB"]
["Sudan, Republic of the","SDN",null,null,null,null,null,null,null,"Somalia","SOM"]
["Suriname","SUR",null,null,null,null,null,null,null,"South Africa","ZAF"]
["Swaziland","SWZ",null,null,null,null,null,null,null,"South Sudan, Republic of","SSD"]
["Syria","SYR",null,null,null,null,null,null,null,"Spcl Unit for South South Coop","H42"]
["Tajikistan","TJK",null,null,null,null,null,null,null,"Sri Lanka","LKA"]
["Thailand","THA",null,null,null,null,null,null,null,"St. Kitts and Nevis","KNA"]
["Timor-Leste","TLS",null,null,null,null,null,null,null,"St. Lucia","LCA"]
["Togo","TGO",null,null,null,null,null,null,null,"St. Vincent and the Grenadines","VCT"]
["Tokelau","TKL",null,null,null,null,null,null,null,"Staff Council Secretariat","H49"]
["Tonga","TON",null,null,null,null,null,null,null,"Sudan, Republic of the","SDN"]
["Trinidad and Tobago","TTO",null,null,null,null,null,null,null,"Suriname","SUR"]
["Tunisia","TUN",null,null,null,null,null,null,null,"Swaziland","SWZ"]
["Turkey","TUR",null,null,null,null,null,null,null,"Syria","SYR"]
["Turkmenistan","TKM",null,null,null,null,null,null,null,"Tajikistan","TJK"]
["Turks and Caicos Islands","TCA",null,null,null,null,null,null,null,"Thailand","THA"]
["Tuvalu","TUV",null,null,null,null,null,null,null,"Timor-Leste","TLS"]
["Uganda","UGA",null,null,null,null,null,null,null,"Togo","TGO"]
["Ukraine","UKR",null,null,null,null,null,null,null,"Tokelau","TKL"]
["UN Capital Development  Fund","H59",null,null,null,null,null,null,null,"Tonga","TON"]
["UN Developmt Coordination Unit","H45",null,null,null,null,null,null,null,"Trinidad and Tobago","TTO"]
["UNDP News","H44",null,null,null,null,null,null,null,"Tunisia","TUN"]
["United Arab Emirates","ARE",null,null,null,null,null,null,null,"Turkey","TUR"]
["United Nations Volunteers","UNV",null,null,null,null,null,null,null,"Turkmenistan","TKM"]
["United Republic of Tanzania","TZA",null,null,null,null,null,null,null,"Turks and Caicos Islands","TCA"]
["Uruguay","URY",null,null,null,null,null,null,null,"Tuvalu","TUV"]
["Uzbekistan","UZB",null,null,null,null,null,null,null,"Uganda","UGA"]
["Vanuatu","VUT",null,null,null,null,null,null,null,"Ukraine","UKR"]
["Venezuela","VEN",null,null,null,null,null,null,null,"UN Capital Development  Fund","H59"]
["Viet Nam","VNM",null,null,null,null,null,null,null,"UN Developmt Coordination Unit","H45"]
["Virgin Islands (British)","VGB",null,null,null,null,null,null,null,"UNDP News","H44"]
["Yemen","YEM",null,null,null,null,null,null,null,"United Arab Emirates","ARE"]
["Zambia","ZMB",null,null,null,null,null,null,null,"United Nations Volunteers","UNV"]
["Zimbabwe","ZWE",null,null,null,null,null,null,null,"United Republic of Tanzania","TZA"]
["Grand Total",null,null,null,null,null,null,null,null,"Uruguay","URY"]
[null,null,null,null,null,null,null,null,null,"Uzbekistan","UZB"]
[null,null,null,null,null,null,null,null,null,"Vanuatu","VUT"]
[null,null,null,null,null,null,null,null,null,"Venezuela","VEN"]
[null,null,null,null,null,null,null,null,null,"Viet Nam","VNM"]
[null,null,null,null,null,null,null,null,null,"Virgin Islands (British)","VGB"]
[null,null,null,null,null,null,null,null,null,"Yemen","YEM"]
[null,null,null,null,null,null,null,null,null,"Zambia","ZMB"]
[null,null,null,null,null,null,null,null,null,"Zimbabwe","ZWE"]